﻿using MockPrjTeam1.Entity;
using SD.Commons.Helpers;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MockPrjTeam1.DAO
{
    public class CountryDAO
    {
        public List<string> GetName()
        {
            var list = new List<string>();

            var results = SqlHelper.ExecuteReader("GetCountryName");

            while (results.Read())
            {
                string item;
                item = results.GetString(0);                
                list.Add(item);
            }

            return list;
        }
    }
}